Tenants with Reader Plugin Feature Enabled

Lists all tenants that have the Reader plugin feature enabled with a valid secret key.

-- Tenants that have "Reader plugin" feature enabled

SELECT
  tenant_id,
  tenants.name,
  tenants.final_domain,
  reader::plugin::$src,
  reader::plugin AS plugin_json,
  reader
FROM
  farfalla.tenants_meta
  JOIN tenants ON tenants_meta.tenant_id = tenants.id
WHERE
  reader LIKE '%"plugin"%'
  AND reader::plugin::secret_key <> 'null'
ORDER BY
  farfalla.tenants_meta.id,
  tenant_id;